package com.jrzh.db.migration.sys;

import com.eroi.migrate.Define.DataTypes;
import com.jrzh.framework.migration.BaseMigration;
import com.jrzh.framework.migration.MigrationHelper;

public class Migration_25 extends BaseMigration{

	private static final String TABLE_NAME = "sys_manege_info";
	
	@Override
	public void down() {
		MigrationHelper.dropColumn("_status", TABLE_NAME);
		MigrationHelper.dropColumn("_end_time", TABLE_NAME);
		MigrationHelper.dropColumn("_start_time", TABLE_NAME);
		MigrationHelper.dropColumn("_charge_type", TABLE_NAME);
		
	}

	@Override
	public void up() {
		log.info("##########执行Sys模块 Migration_24##########Begin");
		addColumn(TABLE_NAME, "_status", "状态", DataTypes.VARCHAR, 256);
		addColumn(TABLE_NAME, "_end_time", "系统终止时间", DataTypes.VARCHAR, 256);
		addColumn(TABLE_NAME, "_start_time", "系统启用时间", DataTypes.VARCHAR, 256);
		addColumn(TABLE_NAME, "_charge_type", "系统收费类型", DataTypes.VARCHAR, 256);
		log.info("##########执行Sys模块 Migration_24##########End");
	}

}
